SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DnnProduct_GetModulePermissionsByTabID]
	
	@TabID int

AS
SELECT *
FROM dbo.DnnProduct_vw_ModulePermissions MP
	INNER JOIN dbo.DnnProduct_TabModules TM on MP.ModuleID = TM.ModuleID
WHERE  TM.TabID = @TabID

GO
